Expressions.String value function

A function returning a string value

Format

{ Character substring function |

Fold function |

Trim function |

Element function |

Replace function |

Translate function |

SubstringRegex function |

Soundex function }

Remarks

A string function returns a string value and can be any one of the following:

• A SUBSTRING function to return a substring from another string. Refer to Character substring function for more details.
• A text case conversion function, such as UPPER or LOWER. Refer to Fold function for more details.
• A TRIM function to remove whitespace from a string. Refer to Trim function for more details.
• An ELEMENT function to extract an element from a string of delimiter separated elements. Refer to Element function for more details.
• A REPLACE function to replace part of a string. Refer to Replace function for more details.
• A SOUNDEX function to return the SOUNDEX code for a string. Refer to Soundex function for more details.
• A TRANSLATE function to return the application dictionary translated code for a string. Refer to Translate function for more details.
• A SUBSTRING_REGEX function to return a substring from another string using regular expression pattern matching. Refer to Regex substring function for more details.